Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 170089 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 16.9 MiB |
| Average record size in memory | 104.0 B |
Variable types
| Numeric | 11 |
|---|---|
| Categorical | 2 |
uri has a high cardinality: 170089 distinct values | High cardinality |
energy is highly overall correlated with loudness and 1 other fields | High correlation |
loudness is highly overall correlated with energy and 1 other fields | High correlation |
acousticness is highly overall correlated with energy and 1 other fields | High correlation |
uri is uniformly distributed | Uniform |
uri has unique values | Unique |
key has 20373 (12.0%) zeros | Zeros |
instrumentalness has 58312 (34.3%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-30 18:14:58.602352 |
|---|---|
| Analysis finished | 2023-04-30 18:15:13.846899 |
| Duration | 15.24 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
danceability
Real number (ℝ)
| Distinct | 1203 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.56977831 |
| Minimum | 0 |
|---|---|
| Maximum | 0.991 |
| Zeros | 97 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.261 |
| Q1 | 0.458 |
| median | 0.581 |
| Q3 | 0.695 |
| 95-th percentile | 0.8326 |
| Maximum | 0.991 |
| Range | 0.991 |
| Interquartile range (IQR) | 0.237 |
Descriptive statistics
| Standard deviation | 0.1717207 |
|---|---|
| Coefficient of variation (CV) | 0.3013816 |
| Kurtosis | -0.23993926 |
| Mean | 0.56977831 |
| Median Absolute Deviation (MAD) | 0.118 |
| Skewness | -0.33197851 |
| Sum | 96913.023 |
| Variance | 0.029487998 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.608 | 439 | 0.3% |
| 0.573 | 433 | 0.3% |
| 0.606 | 428 | 0.3% |
| 0.571 | 422 | 0.2% |
| 0.603 | 421 | 0.2% |
| 0.565 | 420 | 0.2% |
| 0.607 | 413 | 0.2% |
| 0.564 | 412 | 0.2% |
| 0.581 | 411 | 0.2% |
| 0.559 | 408 | 0.2% |
| Other values (1193) | 165882 |
| Value | Count | Frequency (%) |
| 0 | 97 | |
| 0.0567 | 1 | < 0.1% |
| 0.0568 | 2 | < 0.1% |
| 0.0573 | 2 | < 0.1% |
| 0.0591 | 1 | < 0.1% |
| 0.0596 | 1 | < 0.1% |
| 0.0598 | 1 | < 0.1% |
| 0.0599 | 1 | < 0.1% |
| 0.0601 | 1 | < 0.1% |
| 0.0602 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.991 | 1 | < 0.1% |
| 0.988 | 1 | < 0.1% |
| 0.986 | 1 | < 0.1% |
| 0.985 | 1 | < 0.1% |
| 0.984 | 4 | |
| 0.983 | 2 | |
| 0.982 | 4 | |
| 0.981 | 3 | |
| 0.98 | 4 | |
| 0.979 | 2 |
energy
Real number (ℝ)
| Distinct | 2124 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.62201827 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 21 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.158 |
| Q1 | 0.459 |
| median | 0.66 |
| Q3 | 0.82 |
| 95-th percentile | 0.949 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.361 |
Descriptive statistics
| Standard deviation | 0.24179157 |
|---|---|
| Coefficient of variation (CV) | 0.38872102 |
| Kurtosis | -0.53050464 |
| Mean | 0.62201827 |
| Median Absolute Deviation (MAD) | 0.176 |
| Skewness | -0.5505159 |
| Sum | 105798.47 |
| Variance | 0.058463166 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.869 | 321 | 0.2% |
| 0.794 | 318 | 0.2% |
| 0.716 | 318 | 0.2% |
| 0.855 | 317 | 0.2% |
| 0.728 | 315 | 0.2% |
| 0.721 | 315 | 0.2% |
| 0.727 | 313 | 0.2% |
| 0.837 | 308 | 0.2% |
| 0.867 | 306 | 0.2% |
| 0.717 | 306 | 0.2% |
| Other values (2114) | 166952 |
| Value | Count | Frequency (%) |
| 0 | 21 | |
| 2 × 10-5 | 1 | < 0.1% |
| 2.02 × 10-5 | 2 | < 0.1% |
| 2.03 × 10-5 | 1 | < 0.1% |
| 2.05 × 10-5 | 1 | < 0.1% |
| 4.87 × 10-5 | 1 | < 0.1% |
| 5.62 × 10-5 | 1 | < 0.1% |
| 6.9 × 10-5 | 1 | < 0.1% |
| 7.08 × 10-5 | 1 | < 0.1% |
| 9.84 × 10-5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 8 | < 0.1% |
| 0.999 | 19 | < 0.1% |
| 0.998 | 60 | |
| 0.997 | 57 | |
| 0.996 | 84 | |
| 0.995 | 101 | |
| 0.994 | 112 | |
| 0.993 | 135 | |
| 0.992 | 102 | |
| 0.991 | 119 |
key
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.2605812 |
| Minimum | 0 |
|---|---|
| Maximum | 11 |
| Zeros | 20373 |
| Zeros (%) | 12.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 11 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.5777138 |
|---|---|
| Coefficient of variation (CV) | 0.68009857 |
| Kurtosis | -1.295705 |
| Mean | 5.2605812 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.0018090546 |
| Sum | 894767 |
| Variance | 12.800036 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 20373 | |
| 7 | 19728 | |
| 2 | 17529 | |
| 9 | 17213 | |
| 1 | 16449 | |
| 5 | 13840 | |
| 11 | 13463 | |
| 4 | 12813 | |
| 6 | 11230 | |
| 8 | 11033 | |
| Other values (2) | 16418 |
| Value | Count | Frequency (%) |
| 0 | 20373 | |
| 1 | 16449 | |
| 2 | 17529 | |
| 3 | 5446 | 3.2% |
| 4 | 12813 | |
| 5 | 13840 | |
| 6 | 11230 | |
| 7 | 19728 | |
| 8 | 11033 | |
| 9 | 17213 |
| Value | Count | Frequency (%) |
| 11 | 13463 | |
| 10 | 10972 | |
| 9 | 17213 | |
| 8 | 11033 | |
| 7 | 19728 | |
| 6 | 11230 | |
| 5 | 13840 | |
| 4 | 12813 | |
| 3 | 5446 | 3.2% |
| 2 | 17529 |
loudness
Real number (ℝ)
| Distinct | 21575 |
|---|---|
| Distinct (%) | 12.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -8.2187895 |
| Minimum | -60 |
|---|---|
| Maximum | 2.766 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 170030 |
| Negative (%) | > 99.9% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -60 |
|---|---|
| 5-th percentile | -17.101 |
| Q1 | -9.955 |
| median | -7.064 |
| Q3 | -5.186 |
| 95-th percentile | -3.266 |
| Maximum | 2.766 |
| Range | 62.766 |
| Interquartile range (IQR) | 4.769 |
Descriptive statistics
| Standard deviation | 4.6157496 |
|---|---|
| Coefficient of variation (CV) | -0.56160942 |
| Kurtosis | 6.565149 |
| Mean | -8.2187895 |
| Median Absolute Deviation (MAD) | 2.211 |
| Skewness | -1.9799435 |
| Sum | -1397925.7 |
| Variance | 21.305144 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -5.682 | 40 | < 0.1% |
| -5.385 | 40 | < 0.1% |
| -5.772 | 39 | < 0.1% |
| -5.603 | 39 | < 0.1% |
| -4.683 | 38 | < 0.1% |
| -5.804 | 38 | < 0.1% |
| -5.296 | 38 | < 0.1% |
| -5.526 | 38 | < 0.1% |
| -6.324 | 38 | < 0.1% |
| -6.018 | 37 | < 0.1% |
| Other values (21565) | 169704 |
| Value | Count | Frequency (%) |
| -60 | 12 | |
| -47.885 | 1 | < 0.1% |
| -47.669 | 1 | < 0.1% |
| -47.042 | 1 | < 0.1% |
| -46.839 | 1 | < 0.1% |
| -45.545 | 1 | < 0.1% |
| -44.749 | 1 | < 0.1% |
| -44.556 | 1 | < 0.1% |
| -44.15 | 1 | < 0.1% |
| -43.886 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2.766 | 1 | |
| 2.745 | 1 | |
| 2.625 | 1 | |
| 2.594 | 1 | |
| 2.574 | 1 | |
| 2.353 | 1 | |
| 2.238 | 1 | |
| 2.172 | 1 | |
| 2.127 | 1 | |
| 2 | 1 |
mode
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 170089 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 112556 | |
| 0 | 57533 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 112556 | |
| 0 | 57533 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 112556 | |
| 0 | 57533 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 170089 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 112556 | |
| 0 | 57533 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 170089 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 112556 | |
| 0 | 57533 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 170089 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 112556 | |
| 0 | 57533 |
speechiness
Real number (ℝ)
| Distinct | 1563 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.087511503 |
| Minimum | 0 |
|---|---|
| Maximum | 0.963 |
| Zeros | 97 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.0279 |
| Q1 | 0.0348 |
| median | 0.0473 |
| Q3 | 0.0889 |
| 95-th percentile | 0.306 |
| Maximum | 0.963 |
| Range | 0.963 |
| Interquartile range (IQR) | 0.0541 |
Descriptive statistics
| Standard deviation | 0.099464025 |
|---|---|
| Coefficient of variation (CV) | 1.1365823 |
| Kurtosis | 14.489718 |
| Mean | 0.087511503 |
| Median Absolute Deviation (MAD) | 0.016 |
| Skewness | 3.2024646 |
| Sum | 14884.744 |
| Variance | 0.0098930923 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.0328 | 561 | 0.3% |
| 0.032 | 558 | 0.3% |
| 0.0332 | 546 | 0.3% |
| 0.031 | 545 | 0.3% |
| 0.0326 | 544 | 0.3% |
| 0.0312 | 538 | 0.3% |
| 0.0316 | 533 | 0.3% |
| 0.0308 | 531 | 0.3% |
| 0.0322 | 529 | 0.3% |
| 0.0318 | 528 | 0.3% |
| Other values (1553) | 164676 |
| Value | Count | Frequency (%) |
| 0 | 97 | |
| 0.0219 | 1 | < 0.1% |
| 0.0222 | 2 | < 0.1% |
| 0.0223 | 2 | < 0.1% |
| 0.0224 | 6 | < 0.1% |
| 0.0225 | 7 | < 0.1% |
| 0.0226 | 6 | < 0.1% |
| 0.0227 | 8 | < 0.1% |
| 0.0228 | 15 | < 0.1% |
| 0.0229 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.963 | 1 | < 0.1% |
| 0.962 | 3 | |
| 0.961 | 3 | |
| 0.96 | 2 | < 0.1% |
| 0.959 | 1 | < 0.1% |
| 0.958 | 3 | |
| 0.956 | 2 | < 0.1% |
| 0.955 | 2 | < 0.1% |
| 0.954 | 6 | |
| 0.953 | 4 |
acousticness
Real number (ℝ)
| Distinct | 4910 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.28731746 |
| Minimum | 0 |
|---|---|
| Maximum | 0.996 |
| Zeros | 25 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.000384 |
| Q1 | 0.019 |
| median | 0.141 |
| Q3 | 0.513 |
| 95-th percentile | 0.931 |
| Maximum | 0.996 |
| Range | 0.996 |
| Interquartile range (IQR) | 0.494 |
Descriptive statistics
| Standard deviation | 0.31830089 |
|---|---|
| Coefficient of variation (CV) | 1.1078369 |
| Kurtosis | -0.59816749 |
| Mean | 0.28731746 |
| Median Absolute Deviation (MAD) | 0.1381 |
| Skewness | 0.90638062 |
| Sum | 48869.539 |
| Variance | 0.10131546 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.995 | 311 | 0.2% |
| 0.994 | 293 | 0.2% |
| 0.993 | 276 | 0.2% |
| 0.103 | 267 | 0.2% |
| 0.101 | 256 | 0.2% |
| 0.11 | 253 | 0.1% |
| 0.114 | 252 | 0.1% |
| 0.102 | 249 | 0.1% |
| 0.119 | 248 | 0.1% |
| 0.111 | 245 | 0.1% |
| Other values (4900) | 167439 |
| Value | Count | Frequency (%) |
| 0 | 25 | |
| 1.07 × 10-6 | 2 | < 0.1% |
| 1.08 × 10-6 | 1 | < 0.1% |
| 1.15 × 10-6 | 1 | < 0.1% |
| 1.2 × 10-6 | 1 | < 0.1% |
| 1.23 × 10-6 | 1 | < 0.1% |
| 1.25 × 10-6 | 1 | < 0.1% |
| 1.27 × 10-6 | 1 | < 0.1% |
| 1.28 × 10-6 | 1 | < 0.1% |
| 1.3 × 10-6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.996 | 85 | < 0.1% |
| 0.995 | 311 | |
| 0.994 | 293 | |
| 0.993 | 276 | |
| 0.992 | 236 | |
| 0.991 | 235 | |
| 0.99 | 186 | |
| 0.989 | 167 | |
| 0.988 | 185 | |
| 0.987 | 180 |
instrumentalness
Real number (ℝ)
| Distinct | 5399 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.12418812 |
| Minimum | 0 |
|---|---|
| Maximum | 0.999 |
| Zeros | 58312 |
| Zeros (%) | 34.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3.73 × 10-5 |
| Q3 | 0.0203 |
| 95-th percentile | 0.876 |
| Maximum | 0.999 |
| Range | 0.999 |
| Interquartile range (IQR) | 0.0203 |
Descriptive statistics
| Standard deviation | 0.2749173 |
|---|---|
| Coefficient of variation (CV) | 2.2137165 |
| Kurtosis | 2.826495 |
| Mean | 0.12418812 |
| Median Absolute Deviation (MAD) | 3.73 × 10-5 |
| Skewness | 2.1079729 |
| Sum | 21123.034 |
| Variance | 0.075579519 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 58312 | |
| 0.926 | 134 | 0.1% |
| 0.911 | 132 | 0.1% |
| 0.899 | 124 | 0.1% |
| 0.906 | 124 | 0.1% |
| 0.912 | 121 | 0.1% |
| 0.905 | 120 | 0.1% |
| 0.917 | 119 | 0.1% |
| 0.91 | 117 | 0.1% |
| 0.89 | 115 | 0.1% |
| Other values (5389) | 110671 |
| Value | Count | Frequency (%) |
| 0 | 58312 | |
| 1 × 10-6 | 27 | < 0.1% |
| 1.01 × 10-6 | 59 | < 0.1% |
| 1.02 × 10-6 | 74 | < 0.1% |
| 1.03 × 10-6 | 75 | < 0.1% |
| 1.04 × 10-6 | 70 | < 0.1% |
| 1.05 × 10-6 | 71 | < 0.1% |
| 1.06 × 10-6 | 71 | < 0.1% |
| 1.07 × 10-6 | 62 | < 0.1% |
| 1.08 × 10-6 | 65 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.999 | 2 | < 0.1% |
| 0.998 | 2 | < 0.1% |
| 0.997 | 1 | < 0.1% |
| 0.996 | 1 | < 0.1% |
| 0.995 | 1 | < 0.1% |
| 0.994 | 5 | |
| 0.993 | 8 | |
| 0.992 | 4 | |
| 0.991 | 1 | < 0.1% |
| 0.99 | 2 | < 0.1% |
liveness
Real number (ℝ)
| Distinct | 1749 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.20091219 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 41 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.05994 |
| Q1 | 0.096 |
| median | 0.127 |
| Q3 | 0.255 |
| 95-th percentile | 0.608 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.159 |
Descriptive statistics
| Standard deviation | 0.17528637 |
|---|---|
| Coefficient of variation (CV) | 0.87245266 |
| Kurtosis | 5.2629844 |
| Mean | 0.20091219 |
| Median Absolute Deviation (MAD) | 0.0469 |
| Skewness | 2.2168695 |
| Sum | 34172.953 |
| Variance | 0.030725312 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.111 | 2023 | 1.2% |
| 0.11 | 1856 | 1.1% |
| 0.108 | 1760 | 1.0% |
| 0.109 | 1710 | 1.0% |
| 0.107 | 1707 | 1.0% |
| 0.105 | 1649 | 1.0% |
| 0.106 | 1638 | 1.0% |
| 0.112 | 1610 | 0.9% |
| 0.103 | 1609 | 0.9% |
| 0.104 | 1571 | 0.9% |
| Other values (1739) | 152956 |
| Value | Count | Frequency (%) |
| 0 | 41 | |
| 0.00673 | 1 | < 0.1% |
| 0.00936 | 1 | < 0.1% |
| 0.0102 | 1 | < 0.1% |
| 0.0109 | 1 | < 0.1% |
| 0.0116 | 1 | < 0.1% |
| 0.0118 | 1 | < 0.1% |
| 0.0119 | 1 | < 0.1% |
| 0.012 | 1 | < 0.1% |
| 0.0121 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 3 | < 0.1% |
| 0.999 | 2 | < 0.1% |
| 0.998 | 5 | |
| 0.997 | 3 | < 0.1% |
| 0.996 | 7 | |
| 0.995 | 7 | |
| 0.994 | 5 | |
| 0.993 | 10 | |
| 0.992 | 12 | |
| 0.991 | 11 |
valence
Real number (ℝ)
| Distinct | 1680 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.47289893 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 111 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.0798 |
| Q1 | 0.265 |
| median | 0.46 |
| Q3 | 0.674 |
| 95-th percentile | 0.906 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.409 |
Descriptive statistics
| Standard deviation | 0.25366017 |
|---|---|
| Coefficient of variation (CV) | 0.53639403 |
| Kurtosis | -0.98871747 |
| Mean | 0.47289893 |
| Median Absolute Deviation (MAD) | 0.204 |
| Skewness | 0.15131354 |
| Sum | 80434.907 |
| Variance | 0.06434348 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.961 | 415 | 0.2% |
| 0.962 | 321 | 0.2% |
| 0.963 | 319 | 0.2% |
| 0.964 | 289 | 0.2% |
| 0.357 | 271 | 0.2% |
| 0.96 | 269 | 0.2% |
| 0.336 | 266 | 0.2% |
| 0.33 | 264 | 0.2% |
| 0.524 | 262 | 0.2% |
| 0.398 | 258 | 0.2% |
| Other values (1670) | 167155 |
| Value | Count | Frequency (%) |
| 0 | 111 | |
| 1 × 10-5 | 14 | < 0.1% |
| 0.00122 | 1 | < 0.1% |
| 0.00392 | 1 | < 0.1% |
| 0.00485 | 1 | < 0.1% |
| 0.00553 | 1 | < 0.1% |
| 0.00602 | 1 | < 0.1% |
| 0.00847 | 1 | < 0.1% |
| 0.00984 | 1 | < 0.1% |
| 0.0115 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 4 | |
| 0.998 | 1 | < 0.1% |
| 0.997 | 1 | < 0.1% |
| 0.995 | 3 | |
| 0.993 | 1 | < 0.1% |
| 0.992 | 1 | < 0.1% |
| 0.991 | 2 | < 0.1% |
| 0.99 | 4 | |
| 0.989 | 2 | < 0.1% |
| 0.988 | 6 |
tempo
Real number (ℝ)
| Distinct | 71241 |
|---|---|
| Distinct (%) | 41.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 121.14205 |
| Minimum | 0 |
|---|---|
| Maximum | 235.781 |
| Zeros | 97 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 77.691 |
| Q1 | 98.007 |
| median | 120.133 |
| Q3 | 139.948 |
| 95-th percentile | 174.2446 |
| Maximum | 235.781 |
| Range | 235.781 |
| Interquartile range (IQR) | 41.941 |
Descriptive statistics
| Standard deviation | 29.39296 |
|---|---|
| Coefficient of variation (CV) | 0.24263218 |
| Kurtosis | -0.17777247 |
| Mean | 121.14205 |
| Median Absolute Deviation (MAD) | 20.155 |
| Skewness | 0.32054288 |
| Sum | 20604930 |
| Variance | 863.94607 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 97 | 0.1% |
| 128.001 | 76 | < 0.1% |
| 127.998 | 70 | < 0.1% |
| 128.013 | 69 | < 0.1% |
| 127.997 | 67 | < 0.1% |
| 128 | 66 | < 0.1% |
| 127.999 | 64 | < 0.1% |
| 127.992 | 64 | < 0.1% |
| 128.002 | 62 | < 0.1% |
| 119.994 | 61 | < 0.1% |
| Other values (71231) | 169393 |
| Value | Count | Frequency (%) |
| 0 | 97 | |
| 31.167 | 1 | < 0.1% |
| 31.988 | 1 | < 0.1% |
| 32.055 | 1 | < 0.1% |
| 32.724 | 1 | < 0.1% |
| 34.082 | 1 | < 0.1% |
| 34.782 | 1 | < 0.1% |
| 34.821 | 1 | < 0.1% |
| 35.204 | 1 | < 0.1% |
| 35.37 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 235.781 | 1 | |
| 232.08 | 1 | |
| 226.705 | 1 | |
| 220.251 | 1 | |
| 220.169 | 1 | |
| 220.16 | 1 | |
| 220.092 | 1 | |
| 219.918 | 1 | |
| 219.785 | 1 | |
| 219.364 | 1 |
uri
Categorical
HIGH CARDINALITY  UNIFORM  UNIQUE 
| Distinct | 170089 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| spotify:track:0UaMYEvWZi0ZqiDOoHU3YI | 1 |
|---|---|
| spotify:track:7hU88dWKOrWmfLk0HhQvSV | 1 |
| spotify:track:1ABGVrP1QEzjMPfzM0KXKt | 1 |
| spotify:track:7jJQzk7Ng6wjc8jk04xXNF | 1 |
| spotify:track:5XagNVHf4diy4zeM5p0VZc | 1 |
| Other values (170084) |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Characters and Unicode
| Total characters | 6123204 |
|---|---|
| Distinct characters | 63 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 170089 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | spotify:track:0UaMYEvWZi0ZqiDOoHU3YI |
|---|---|
| 2nd row | spotify:track:6I9VzXrHxO9rA9A5euc8Ak |
| 3rd row | spotify:track:0WqIKmW4BTrj3eJFmnCKMv |
| 4th row | spotify:track:1AWQoqb9bSvzTjaLralEkT |
| 5th row | spotify:track:1lzr43nnXAijIGYnCT8M8H |
Common Values
| Value | Count | Frequency (%) |
| spotify:track:0UaMYEvWZi0ZqiDOoHU3YI | 1 | < 0.1% |
| spotify:track:7hU88dWKOrWmfLk0HhQvSV | 1 | < 0.1% |
| spotify:track:1ABGVrP1QEzjMPfzM0KXKt | 1 | < 0.1% |
| spotify:track:7jJQzk7Ng6wjc8jk04xXNF | 1 | < 0.1% |
| spotify:track:5XagNVHf4diy4zeM5p0VZc | 1 | < 0.1% |
| spotify:track:2qigyAuvoKtaZZKsnynMFT | 1 | < 0.1% |
| spotify:track:4e3p8QsYgeMf8eOUwZEIOx | 1 | < 0.1% |
| spotify:track:1x4AHWj90fpKObG5URZr9g | 1 | < 0.1% |
| spotify:track:6QFgpUiLoXlmYDjbe0tjyP | 1 | < 0.1% |
| spotify:track:72UnWvJ8X67nAzjaHNamYr | 1 | < 0.1% |
| Other values (170079) | 170079 |
Length
| Value | Count | Frequency (%) |
| spotify:track:0uamyevwzi0zqidoohu3yi | 1 | < 0.1% |
| spotify:track:12qzhaeoytf93yawvgdtat | 1 | < 0.1% |
| spotify:track:215jyyyunrj98nk3kewu6d | 1 | < 0.1% |
| spotify:track:4bp3uh0hflfrb5cjsglqdh | 1 | < 0.1% |
| spotify:track:4pmc2axseq6g7hpvljcpyp | 1 | < 0.1% |
| spotify:track:0wqikmw4btrj3ejfmnckmv | 1 | < 0.1% |
| spotify:track:1awqoqb9bsvztjalralekt | 1 | < 0.1% |
| spotify:track:1lzr43nnxaijigynct8m8h | 1 | < 0.1% |
| spotify:track:0xufyu2qvipas6bxspxyg4 | 1 | < 0.1% |
| spotify:track:68vgtrhr7izhpzgpon6jlo | 1 | < 0.1% |
| Other values (170079) | 170079 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 397686 | 6.5% |
| : | 340178 | 5.6% |
| p | 228160 | 3.7% |
| r | 227844 | 3.7% |
| f | 227806 | 3.7% |
| c | 227786 | 3.7% |
| i | 227765 | 3.7% |
| y | 227759 | 3.7% |
| a | 227741 | 3.7% |
| k | 227623 | 3.7% |
| Other values (53) | 3562856 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3539883 | |
| Uppercase Letter | 1496102 | |
| Decimal Number | 747041 | 12.2% |
| Other Punctuation | 340178 | 5.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 397686 | 11.2% |
| p | 228160 | 6.4% |
| r | 227844 | 6.4% |
| f | 227806 | 6.4% |
| c | 227786 | 6.4% |
| i | 227765 | 6.4% |
| y | 227759 | 6.4% |
| a | 227741 | 6.4% |
| k | 227623 | 6.4% |
| s | 227541 | 6.4% |
| Other values (16) | 1092172 |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 58043 | 3.9% |
| D | 58019 | 3.9% |
| I | 57910 | 3.9% |
| B | 57882 | 3.9% |
| E | 57799 | 3.9% |
| L | 57754 | 3.9% |
| A | 57717 | 3.9% |
| Q | 57709 | 3.9% |
| J | 57689 | 3.9% |
| S | 57665 | 3.9% |
| Other values (16) | 917915 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 79780 | |
| 6 | 79735 | |
| 1 | 79703 | |
| 5 | 79545 | |
| 4 | 79545 | |
| 3 | 79365 | |
| 2 | 79161 | |
| 7 | 74927 | |
| 9 | 57682 | |
| 8 | 57598 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 340178 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5035985 | |
| Common | 1087219 | 17.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 397686 | 7.9% |
| p | 228160 | 4.5% |
| r | 227844 | 4.5% |
| f | 227806 | 4.5% |
| c | 227786 | 4.5% |
| i | 227765 | 4.5% |
| y | 227759 | 4.5% |
| a | 227741 | 4.5% |
| k | 227623 | 4.5% |
| s | 227541 | 4.5% |
| Other values (42) | 2588274 |
Common
| Value | Count | Frequency (%) |
| : | 340178 | |
| 0 | 79780 | 7.3% |
| 6 | 79735 | 7.3% |
| 1 | 79703 | 7.3% |
| 5 | 79545 | 7.3% |
| 4 | 79545 | 7.3% |
| 3 | 79365 | 7.3% |
| 2 | 79161 | 7.3% |
| 7 | 74927 | 6.9% |
| 9 | 57682 | 5.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6123204 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 397686 | 6.5% |
| : | 340178 | 5.6% |
| p | 228160 | 3.7% |
| r | 227844 | 3.7% |
| f | 227806 | 3.7% |
| c | 227786 | 3.7% |
| i | 227765 | 3.7% |
| y | 227759 | 3.7% |
| a | 227741 | 3.7% |
| k | 227623 | 3.7% |
| Other values (53) | 3562856 |
duration_ms
Real number (ℝ)
| Distinct | 65472 |
|---|---|
| Distinct (%) | 38.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 238712.33 |
| Minimum | 3056 |
|---|---|
| Maximum | 5279768 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 3056 |
|---|---|
| 5-th percentile | 136000 |
| Q1 | 192867 |
| median | 225432 |
| Q3 | 266840 |
| 95-th percentile | 376320 |
| Maximum | 5279768 |
| Range | 5276712 |
| Interquartile range (IQR) | 73973 |
Descriptive statistics
| Standard deviation | 100754 |
|---|---|
| Coefficient of variation (CV) | 0.42207288 |
| Kurtosis | 381.35906 |
| Mean | 238712.33 |
| Median Absolute Deviation (MAD) | 36139 |
| Skewness | 11.827945 |
| Sum | 4.0602341 × 1010 |
| Variance | 1.0151368 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 240000 | 138 | 0.1% |
| 192000 | 88 | 0.1% |
| 180000 | 85 | < 0.1% |
| 210000 | 70 | < 0.1% |
| 216000 | 70 | < 0.1% |
| 204000 | 64 | < 0.1% |
| 228000 | 58 | < 0.1% |
| 200000 | 57 | < 0.1% |
| 220000 | 56 | < 0.1% |
| 270000 | 54 | < 0.1% |
| Other values (65462) | 169349 |
| Value | Count | Frequency (%) |
| 3056 | 9 | |
| 4000 | 1 | < 0.1% |
| 4107 | 1 | < 0.1% |
| 4227 | 1 | < 0.1% |
| 4520 | 1 | < 0.1% |
| 4800 | 1 | < 0.1% |
| 4876 | 1 | < 0.1% |
| 5227 | 1 | < 0.1% |
| 5471 | 1 | < 0.1% |
| 5887 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5279768 | 1 | |
| 5062000 | 1 | |
| 4788939 | 1 | |
| 4556388 | 1 | |
| 4500037 | 1 | |
| 4497994 | 1 | |
| 4436000 | 1 | |
| 4316155 | 1 | |
| 4276000 | 1 | |
| 4120258 | 1 |
| danceability | energy | key | loudness | speechiness | acousticness | instrumentalness | liveness | valence | tempo | duration_ms | mode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| danceability | 1.000 | 0.107 | 0.029 | 0.132 | 0.243 | -0.113 | -0.164 | -0.108 | 0.478 | -0.088 | -0.060 | 0.093 |
| energy | 0.107 | 1.000 | 0.033 | 0.780 | 0.317 | -0.677 | -0.106 | 0.172 | 0.325 | 0.200 | 0.009 | 0.080 |
| key | 0.029 | 0.033 | 1.000 | 0.018 | 0.041 | -0.028 | -0.003 | 0.001 | 0.041 | 0.003 | 0.006 | 0.250 |
| loudness | 0.132 | 0.780 | 0.018 | 1.000 | 0.214 | -0.553 | -0.298 | 0.118 | 0.242 | 0.161 | -0.036 | 0.049 |
| speechiness | 0.243 | 0.317 | 0.041 | 0.214 | 1.000 | -0.205 | -0.174 | 0.101 | 0.170 | 0.083 | -0.070 | 0.095 |
| acousticness | -0.113 | -0.677 | -0.028 | -0.553 | -0.205 | 1.000 | 0.019 | -0.084 | -0.125 | -0.190 | -0.089 | 0.085 |
| instrumentalness | -0.164 | -0.106 | -0.003 | -0.298 | -0.174 | 0.019 | 1.000 | -0.085 | -0.234 | -0.007 | 0.143 | 0.053 |
| liveness | -0.108 | 0.172 | 0.001 | 0.118 | 0.101 | -0.084 | -0.085 | 1.000 | 0.005 | 0.026 | -0.031 | 0.028 |
| valence | 0.478 | 0.325 | 0.041 | 0.242 | 0.170 | -0.125 | -0.234 | 0.005 | 1.000 | 0.051 | -0.190 | 0.027 |
| tempo | -0.088 | 0.200 | 0.003 | 0.161 | 0.083 | -0.190 | -0.007 | 0.026 | 0.051 | 1.000 | 0.003 | 0.039 |
| duration_ms | -0.060 | 0.009 | 0.006 | -0.036 | -0.070 | -0.089 | 0.143 | -0.031 | -0.190 | 0.003 | 1.000 | 0.000 |
| mode | 0.093 | 0.080 | 0.250 | 0.049 | 0.095 | 0.085 | 0.053 | 0.028 | 0.027 | 0.039 | 0.000 | 1.000 |
| danceability | energy | key | loudness | mode | speechiness | acousticness | instrumentalness | liveness | valence | tempo | uri | duration_ms | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0.904 | 0.813 | 4 | -7.105 | 0 | 0.1210 | 0.03110 | 0.006970 | 0.0471 | 0.810 | 125.461 | spotify:track:0UaMYEvWZi0ZqiDOoHU3YI | 226864 |
| 1 | 0.774 | 0.838 | 5 | -3.914 | 0 | 0.1140 | 0.02490 | 0.025000 | 0.2420 | 0.924 | 143.040 | spotify:track:6I9VzXrHxO9rA9A5euc8Ak | 198800 |
| 2 | 0.664 | 0.758 | 2 | -6.583 | 0 | 0.2100 | 0.00238 | 0.000000 | 0.0598 | 0.701 | 99.259 | spotify:track:0WqIKmW4BTrj3eJFmnCKMv | 235933 |
| 3 | 0.892 | 0.714 | 4 | -6.055 | 0 | 0.1410 | 0.20100 | 0.000234 | 0.0521 | 0.817 | 100.972 | spotify:track:1AWQoqb9bSvzTjaLralEkT | 267267 |
| 4 | 0.853 | 0.606 | 0 | -4.596 | 1 | 0.0713 | 0.05610 | 0.000000 | 0.3130 | 0.654 | 94.759 | spotify:track:1lzr43nnXAijIGYnCT8M8H | 227600 |
| 5 | 0.881 | 0.788 | 2 | -4.669 | 1 | 0.1680 | 0.02120 | 0.000000 | 0.0377 | 0.592 | 104.997 | spotify:track:0XUfyU2QviPAs6bxSpXYG4 | 250373 |
| 6 | 0.662 | 0.507 | 5 | -8.238 | 1 | 0.1180 | 0.25700 | 0.000000 | 0.0465 | 0.676 | 86.412 | spotify:track:68vgtRHr7iZHpzGpon6Jlo | 223440 |
| 7 | 0.570 | 0.821 | 2 | -4.380 | 1 | 0.2670 | 0.17800 | 0.000000 | 0.2890 | 0.408 | 210.857 | spotify:track:3BxWKCI06eQ5Od8TY2JBeA | 225560 |
| 8 | 0.713 | 0.678 | 5 | -3.525 | 0 | 0.1020 | 0.27300 | 0.000000 | 0.1490 | 0.734 | 138.009 | spotify:track:7H6ev70Weq6DdpZyyTmUXk | 271333 |
| 9 | 0.727 | 0.974 | 4 | -2.261 | 0 | 0.0664 | 0.10300 | 0.000532 | 0.1740 | 0.965 | 79.526 | spotify:track:2PpruBYCo4H7WOBJ7Q2EwM | 235213 |
| danceability | energy | key | loudness | mode | speechiness | acousticness | instrumentalness | liveness | valence | tempo | uri | duration_ms | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 170079 | 0.358 | 0.963 | 7 | -3.725 | 1 | 0.1040 | 0.013600 | 0.000363 | 0.3470 | 0.105 | 157.450 | spotify:track:0l6uRRIDPNw3OsmqCYkmvi | 328400 |
| 170080 | 0.443 | 0.911 | 9 | -4.208 | 0 | 0.0851 | 0.012400 | 0.000000 | 0.2780 | 0.680 | 160.152 | spotify:track:642Zd1NC6fLzbLhjQ8ykcZ | 90375 |
| 170081 | 0.542 | 0.981 | 2 | -2.966 | 0 | 0.0779 | 0.000129 | 0.000030 | 0.1440 | 0.451 | 139.958 | spotify:track:2aFVXUcOs57iVKYM0if4S4 | 154286 |
| 170082 | 0.739 | 0.521 | 3 | -5.479 | 0 | 0.0707 | 0.164000 | 0.000089 | 0.4320 | 0.812 | 99.993 | spotify:track:2AbwQmeiU43d4eIe2DkpYr | 207000 |
| 170083 | 0.685 | 0.536 | 11 | -11.036 | 0 | 0.1130 | 0.678000 | 0.000000 | 0.1930 | 0.758 | 66.329 | spotify:track:5LnFmGMIGaIx4WoGFNWz33 | 135609 |
| 170084 | 0.551 | 0.822 | 11 | -7.018 | 0 | 0.0614 | 0.001540 | 0.000000 | 0.2150 | 0.360 | 127.043 | spotify:track:4cKPzfOUIZWXhu3GDnESjL | 265039 |
| 170085 | 0.480 | 0.761 | 6 | -4.628 | 1 | 0.0367 | 0.120000 | 0.000000 | 0.2960 | 0.359 | 160.020 | spotify:track:0VICzaRdctD8XGfDstBjQY | 368767 |
| 170086 | 0.402 | 0.767 | 11 | -6.718 | 0 | 0.1710 | 0.000077 | 0.000003 | 0.3930 | 0.558 | 178.293 | spotify:track:0B4YuevrDNhh71edZrFiOs | 179267 |
| 170087 | 0.678 | 0.826 | 0 | -4.742 | 0 | 0.0591 | 0.005240 | 0.000000 | 0.0951 | 0.706 | 139.989 | spotify:track:7i9q0VPbENCoYnJUsJhX9d | 242347 |
| 170088 | 0.670 | 0.483 | 9 | -7.124 | 0 | 0.1250 | 0.213000 | 0.000000 | 0.0550 | 0.770 | 170.115 | spotify:track:6uaJuze0LunPtcbCu1JNtq | 169390 |